Release 10.1A: OpenEdge Data Management:
SQL Development

Determining database server requirements

To properly manage database connections for both OpenEdge SQL and Progress 4GL servers, you must first assess your startup parameter requirements. The OpenEdge SQL server and the Progress 4GL server should be managed independently from each other. This section describes the process for determining server startup parameters.

To analyze database server requirements:
  1. Determine if your database supports both SQL and 4GL users.

  2. Determine for each server type, SQL and 4GL:

    • The maximum number of servers.
    • The maximum number of servers per broker.
    • The maximum number of remote clients per server.
  3. Calculate the maximum number of database users by using the following formula:

    4. -n = Maximum SQL users + Maximum 4GL users + One per each additional broker + all other processes (APWs, BIWs, AIWs, PROMONs, online backups).

  4. Calculate the maximum number of database servers and brokers using the following formula:

    5. -Mn = (Sum of all Mpb values) + one per each additional broker.

Copyright © 2005 Progress Software Corporation
 www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095